SELECT Customer.cust_id, Customer.company, Orders.order_id,; Orditems.line_no; FROM testdata!customer INNER JOIN testdata!orders; INNER JOIN testdata!orditems ; ON Orders.order_id = Orditems.order_id ; ON Customer.cust_id = Orders.cust_id